package com.leaf.lowcode.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.leaf.lowcode.entity.ApptionmentBean;
import com.leaf.lowcode.entity.HkVistor;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author cxd
 * @since 2021-11-02
 */
public interface ApptionmentMapper extends BaseMapper<ApptionmentBean> {
    @Select("select * from hk_appiont where orderId = #{orderId}")
    ApptionmentBean selectId(String orderId);
    @Select("select count(*) from hk_appiont")
    int selectSum();
    @Select("SELECT COUNT(*),DATE_FORMAT(`visitStartTime`,'%j') dayint FROM hk_appiont GROUP BY dayint")
    public List<String> sumElectricityProduction();

}
